SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[spAlumnoAusentes]
@fecha varchar(10),
@idAlumno int,
@division int
 AS

SET NOCOUNT ON
declare @FFecha datetime
if @fecha <> ''
	Select @FFecha = cast(@fecha as datetime)


if exists(Select * from tb_Inasistencias where Alumno = @idAlumno and Fecha = @FFecha)
	return(Select causa from tb_Inasistencias where Alumno = @idAlumno and fecha = @FFecha)
else
	return(-1)
GO
